<?php
/******************************
 * EQdkp
 * Copyright 2002-2003
 * Licensed under the GNU GPL.  See COPYING for full terms.
 * ------------------
 * FFXI.php
 * Began: November 2007
 *
 *
 ******************************/

if ( !defined('EQDKP_INC') )
{
    die('Hacking attempt');
}

class Manage_Game extends EQdkp_Admin
{

 function do_it()
 {

   global $db, $eqdkp, $user;
   global $SID, $dbname, $table_prefix;


   parent::eqdkp_admin();


$queries = array(

"TRUNCATE TABLE ". $table_prefix ."classes;",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (0, 'Unknown', 'Unk', 'Unknown', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (1, 'Warrior', 'WAR', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (2, 'White Mage', 'WHM', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (3, 'Monk', 'MNK', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (4, 'Black Mage', 'BLM', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (5, 'Thief', 'THF', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (6, 'Red Mage', 'RDM', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (7, 'Paladin', 'PLD', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (8, 'Dark Knight', 'DRK', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (9, 'Beastmaster', 'BST', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (10, 'Bard', 'BRD', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (11, 'Ranger', 'RNG', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (12, 'Samurai', 'SAM', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (13, 'Ninja', 'NIN', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (14, 'Dragoon', 'DRG', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (15, 'Summoner', 'SMN', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (16, 'Blue Mage', 'BLU', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (17, 'Corsair', 'COR', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (18, 'Puppetmaster', 'PUP', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (19, 'Dancer', 'DNC', 'armor_type', '1', '75');",
"INSERT INTO ". $table_prefix ."classes (class_id, class_name, class_short_name, class_armor_type, class_min_level, class_max_level) VALUES (20, 'Scholar', 'SCH', 'armor_type', '1', '75');",

"TRUNCATE TABLE ". $table_prefix ."races;",

"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (0, 'Unknown');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (1, 'Elvaan');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (2, 'Mithra');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (3, 'Galka');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (4, 'Tarutaru');",
"INSERT INTO ". $table_prefix ."races (race_id, race_name) VALUES (5, 'Hume');",

"TRUNCATE TABLE ". $table_prefix ."factions;",

"INSERT INTO ". $table_prefix ."factions (faction_id, faction_name) VALUES (1, 'Bastok');",
"INSERT INTO ". $table_prefix ."factions (faction_id, faction_name) VALUES (2, 'Windurst');",
"INSERT INTO ". $table_prefix ."factions (faction_id, faction_name) VALUES (3, 'Sandoria');",

// Item Data
"TRUNCATE TABLE ".$table_prefix."item_data;",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Gauntlets', '[Hands] All Races ', 'DEF: 20 MP +20 DEX +5 INT +8', 'Dark magic skill +5', '', '', ' DRK', 72, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Bonnet', '[Head] All Races ', 'DEF: 24 HP +16 DEX +5 Enmity +2 ', 'Enhances \"Mug\" effect ', '', '', ' THF', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Duckbills', '[Feet] All Races', 'DEF: 15 MP +18 MND +5', 'Enhancing magic skill +10', 'Enmity -1', '', ' WHM', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Hatsuburi', '[Head] All Races', 'DEF: 22 HP+20', 'Enhances ninjutsu damage', 'Nighttime: Parrying skill +10', '', ' NIN', 73, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Helm', '[Head] All Races', 'DEF: 26 HP +19 CHR +4 Parrying skill +3', '\"Charm\" +5', '', '', ' BST', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Haidate', '[Legs] All Races ', 'DEF: 40 HP +18 AGI +3 Enmity +1', 'Enhances \"Third Eye\" effect', '', '', ' SAM', 72, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Bracers', '[Hands] All Races', 'DEF: 14 HP +13 AGI +5', 'Evasion +7 Enmity -2', '', '', ' RNG', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Gloves', '[Hands] All Races', 'DEF: 15 MP +24', 'Dark magic skill +10 Enmity -2', 'Bonus damage added to magic burst', '', ' BLM', 72, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Spats', '[Legs] All Races ', 'DEF: 29 MP +20 MND +3', 'Shortens casting time for elemental avatars', '\"Blood Pact\" ability delay -2', '', ' SMN', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Leggings', '[Feet] All Races', 'DEF: 19 HP +18 MND +3 Enmity +1', 'Enhances \"Sentinel\" effect', '', '', ' PLD', 71, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Mask', '[Head] All Races', 'DEF: 28 DEX +5 Parrying skill +5', 'Enmity +1', 'Enhances \"Warcry\" effect', '', ' WAR', 73, 'Dynamis - Windurst', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Roundlet', '[Head] All Races', 'DEF: 19 HP +13 CHR +5', 'Singing skill +5 Enmity -3', '', '', ' BRD', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Cap', '[Head] All Races ', 'DEF: 24 MP +25 VIT +4 Enmity -4 ', 'Enhances \"Resist Silence\" effect ', '', '', ' WHM', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Boots', '[Feet] All Races ', 'DEF: 15 MP +15 MND +4 ', 'Evasion skill +5 ', '\"Magic Atk. Bonus\" +4', '', ' RDM', 71, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Hakama', '[Legs] All Races ', 'DEF: 31 HP +40', 'Enhances \"Dual Wield\" effect', 'Nighttime: Evasion +10', '', ' NIN', 71, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Hose', '[Legs] All Races', 'DEF: 31 HP +6% AGI +4', '\"Kick Attacks\" +5', '\"Subtle Blow\" +5', '', ' MNK', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Trousers', '[Legs] All Races', 'DEF: 34 HP +17 DEX +4', 'HP recovered while healing +3', '\"Charm\" +2', '', ' BST', 73, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Braccae', '[Legs] All Races', 'DEF: 32 HP +18 Ranged Accuracy +7', 'Parrying skill +10 Enmity -2', '', '', ' RNG', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Pigaches', '[Feet] All Races ', 'DEF: 14 MP +20 VIT +3', 'Enhances avatar attack', '\"Blood Pact\" ability delay -2', '', ' SMN', 73, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Gauntlets', '[Hands] All Races', 'DEF: 22 HP +16 VIT +5 Enmity +3', '\"Shield Bash\" +10', '', '', ' PLD', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Calligae', '[Feet] All Races', 'DEF: 19 HP +10 AGI +5 Enmity +1', 'Enhances \"Berserk\" effect', '', '', ' WAR', 71, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Greaves', '[Feet] All Races', 'DEF: 16 HP +10 VIT +4 Resist Vs. Ice +10', 'Wyvern: HP recovered while healing +6', '', '', ' DRG', 72, 'Dynamis - San d''Oria', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Sollerets', '[Feet] All Races', 'DEF: 17 MP +12', 'Enfeebling magic skill +5', 'Enhances \"Last Resort\" effect', '', ' DRK', 71, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Vest', '[Body] All Races ', 'DEF: 45 HP +22 AGI +4 Enmity +3 ', 'Increases rate of critical hits ', '', '', ' THF', 72, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Cuffs', '[Hands] All Races', 'DEF: 18 HP +16 Evasion +5', 'Wind instrument skill +3', 'Enmity -3', '', ' BRD', 73, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Gloves', '[Hands] All Races ', 'DEF: 17 MP +18 INT +4 ', 'Enhancing magic skill +15 ', '\"Magic Def. Bonus\" +2 ', '', ' RDM', 72, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Gaiters', '[Feet] All Races', 'DEF: 15 HP +4% DEX +4', 'Guarding skill +12', 'Enhances \"Counterstance\" effect', '', ' MNK', 71, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Jackcoat', '[Body] All Races', 'DEF: 49 HP +21 INT +6', 'Enhances \"Reward\" effect', '\"Charm\" +6', '', ' BST', 72, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Kote', '[Hands] All Races', 'DEF: 21 HP +10 Attack +10 Enmity +1', 'Enhances \"Meditate\" effect', '', '', ' SAM', 73, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Tonban', '[Legs] All Races ', 'DEF: 30 MP +13 INT +3 Enmity -2 ', 'Elemental magic affected by day', '', '', ' BLM', 73, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Bracers', '[Hands] All Races ', 'DEF: 15 MP +25', 'Summoning magic skill +10', '\"Blood Pact\" ability delay -2', 'Enhances avatar accuracy', ' SMN', 72, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Coronet', '[Head] All Races', 'DEF: 28 HP +18', 'Healing magic skill +10', 'Enmity +3', 'Enhances \"Rampart\" effect', ' PLD', 73, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Brais', 'DEF: 32 HP +13 DEX +5', 'Enhances \"High Jump\" effect', 'Wyvern: Physical Damage Taken -5%', '', '', ' DRG', 71, 'Dynamis - Bastok', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Flanchard', '[Legs] All Races', 'DEF: 38 MP +18 MND +5', 'Dark magic skill +5', '\"Magic Def. Bonus\" +5', '', ' DRK', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Poulaines', '[Feet] All Races ', 'DEF: 15 HP +15 CHR +5 ', '\"Triple Attack\" +1 ', 'Enmity +2 ', '', ' THF', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Slippers', '[Feet] All Races ', 'DEF: 14 HP +12', 'Parrying skill +3', 'String instrument skill +3', 'Enmity -2', ' BRD', 71, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Pantaloons', '[Legs] All Races ', 'DEF: 31 MP +17 ', 'Healing magic skill +15 Enmity -2 ', 'Elemental resistance spells +20 ', '', ' WHM', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Tights', '[Legs] All Races ', 'DEF: 33 MP +16 DEX +5 ', 'Elemental magic skill +10 ', 'Enhances effect of \"Spikes\" spells ', '', ' RDM', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Kyahan', '[Feet] All Races', 'DEF: 15 VIT +7 Ninjutsu skill +10', 'Nighttime: DEX +7', '', '', ' NIN', 72, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Gloves', '[Hands] All Races', 'DEF: 15 HP +3% Attack +16', '\"Subtle Blow\" +4', 'Enhances \"Chakra\" effect', '', ' MNK', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Sune-Ate', '[Feet] All Races', 'DEF: 18 HP +23 DEX +5', 'Attack +8 Enmity +1', '', '', ' SAM', 71, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Beret', '[Head] All Races', 'DEF: 24 HP +15 MND +4 Enmity -3', '\"Recycle\" ', '', '', ' RNG', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Sabots', '[Feet] All Races ', 'DEF: 14 MP +18 INT +2 Enmity -1 ', '\"Conserve MP\" +5 ', '', '', ' BLM', 71, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Mufflers', '[Hands] All Races', 'DEF: 22 HP +20 VIT +5', 'Attack +12 Enmity +2', '', '', ' WAR', 72, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Finger Gauntlets', '[Hands] All Races', 'DEF: 19 HP +16 AGI +3 Accuracy +5', 'Wyvern: Magic Damage Taken -5%', '', '', ' DRG', 73, 'Dynamis - Jeuno', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Cuirass', '[Body] All Races', 'DEF: 49 HP +20 MND +4 Accuracy +10', '\"Magic Atk. Bonus\" +10', '', '', ' DRK', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Culotte', '[Legs] All Races', 'DEF: 34 HP +19 Enmity +4 \"Steal\" +5', 'Enhances \"Gilfinder\" effect', '', '', ' THF', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Justaucorps', '[Body] All Races', 'DEF: 45 HP +19 ', 'Attack +18', '\"Military Parade\"', '', ' BRD', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Briault', '[Body] All Races ', 'DEF: 42 MP +24 Enmity -2 ', 'Adds \"Refresh\" effect ', 'Enhances potency of \"Regen\" ', '', ' WHM', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Tabard', '[Body] All Races ', 'DEF: 45 MP +24 AGI +4 ', 'Healing magic skill +10 ', 'Enhances \"Fast Cast\" effect', '', ' RDM', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Chainmail', '[Body] All Races ', 'DEF: 46 Accuracy +12 Attack +16', 'Ranged Accuracy +8 Ranged Attack +8', '', '', ' NIN', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Cyclas', '[Body] All Races', 'DEF: 44 HP +5% VIT +5', 'Adds \"Regen\" effect', 'HP recovered while healing +6', '', ' MNK', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Gaiters', '[Feet] All Races', 'DEF: 14 HP +13 VIT +4', 'Enhances \"Reward\" effect', '\"Charm\" +3', '', ' BST', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Domaru', '[Body] All Races', 'DEF: 50 HP +34 VIT +6', '\"Store TP\" +3', 'Enmity +1', '', ' SAM', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Socks', '[Feet] All Races', 'DEF: 16 HP +12 VIT +5', 'Ranged Attack +10 Enmity -3', '', '', ' RNG', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Coat', '[Body] All Races ', 'DEF: 41 MP +12 ', 'Elemental magic skill +5 Enmity -2 ', 'Adds \"Refresh\" effect ', '', ' BLM', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Doublet', '[Body] All Races ', 'DEF: 38 MP +20', '\"Blood Pact\" ability delay -3', 'Avatar''s critical hit rate +3%', 'Depending on day: Avatar perpetuation cost -3', ' SMN', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Breeches', '[Legs] All Races', 'DEF: 43 HP +20 STR +5 Enmity +3', 'Spell interruption rate down 10%', '', '', ' PLD', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Cuisses', '[Legs] All Races', 'DEF: 39 STR +5 Enmity +3', '\"Double Attack\" +1', '', '', ' WAR', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Mail', '[Body] All Races', 'DEF: 49 HP +24 Parrying skill +15', 'Enhances \"Resist Blind\" effect', 'Adds support job abilities to wyvern', '', ' DRG', 74, 'Dynamis - Beaucedine', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Burgeonet', '[Head] All Races', 'DEF: 27 HP +30 VIT +7 Attack +10', 'Enhances \"Resist Paralyze\" effect', '', '', ' DRK', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Armlets', '[Hands] All Races', 'DEF: 16 HP +7 CHR +5 Enmity +3', '\"Treasure Hunter\" +1', '', '', ' THF', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Cannions', '[Legs] All Races', 'DEF: 31 HP +17 MP +42', '\"Courtly Measure\"', '', '', ' BRD', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Mitts', '[Hands] All Races ', 'DEF: 16 MP +20 ', 'Enfeebling magic skill +15 ', 'Enmity -3 ', 'Enhances potency of \"Banish\" vs. undead ', ' WHM', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Chapeau', '[Head] All Races ', 'DEF: 24 MP +14 Resist Vs. Wind +10', 'Enfeebling magic skill +15', 'Adds \"Refresh\" effect ', '', ' RDM', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Tekko', '[Hands] All Races', 'DEF: 18', '\"Ninja tool expertise\"', 'Nighttime: STR +12 Haste +4%', '', ' NIN', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Crown', '[Head] All Races', 'DEF: 23 HP +4% STR +5 Enmity -3', '\"Subtle Blow\" +6', '', '', ' MNK', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Gloves', '[Hands] All Races', 'DEF: 15 HP +14 AGI +4', 'Enhances \"Call Beast\" effect', '\"Charm\" +4', '', ' BST', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Kabuto', '[Head] All Races', 'DEF: 25 HP +20 Accuracy +10', 'Ranged Accuracy +5 Enmity +1', '', '', ' SAM', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Jerkin', '[Body] All Races', 'DEF: 45 HP +23 DEX +4', '\"Rapid Shot\" +5', 'Enmity -2', '', ' RNG', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Petasos', '[Head] All Races ', 'DEF: 23 MP +23 ', 'Enfeebling magic skill +5 ', 'Elemental magic skill +10 ', 'Enmity -2 ', ' BLM', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Horn', '[Head] All Races ', 'DEF: 18 MP +25 INT +3', '\"Blood Pact\" ability delay -3', 'Weather: Avatar perpetuation cost -3', '', ' SMN', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Armet', '[Head] All Races', 'DEF: 25 HP +16 STR +4 Resist Vs. Wind +10', 'Enhances effect of wyvern''s breath', '', '', ' DRG', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Surcoat', '[Body] All Races', 'DEF: 55 HP +23 DEX +3 Enmity +4', 'Enhances \"Cover\" effect', '', '', ' PLD', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Lorica', '[Body] All Races', 'DEF: 50 HP +10 Attack +10 Enmity +4', 'Enhances \"Aggressor\" effect', '', '', ' WAR', 75, 'Dynamis - Xarcabard', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Shadow Mantle', '[Back] All Races ', 'Def: 15', 'Occasionally annuls damage', 'from physical attacks', 'On Darksday: VIT +20', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 75, 'Dynamis Lord', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Shadow Ring', '[Ring] All Races ', 'Occasionally annulls magic damage taken', 'Enhances resistance against \"Death\"', 'On Darksdays:', '\"Magic Def. Bonus\"', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 75, 'Dynamis Lord', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Assassin''s Cape', '[Back] All Races ', 'DEF: 7 DEX +4 AGI +4 Enmity +5 ', '', '', '', ' THF', 70, 'Dynamis - Qufim / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Bard''s Cape', '[Back] All Races', 'DEF: 6 CHR +7 Accuracy +7 Evasion +7', '', '', '', ' BRD', 70, 'Dynamis - Buburimu / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Cleric''s Belt', '[Waist] All Races', 'DEF: 4 MP +40 MND +6', 'MP recovered while healing +3', '', '', ' WHM', 70, 'Dynamis - Qufim / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Koga Sarashi', '[Waist] All Races ', 'DEF: 4 Evasion +4 Haste +4%', 'Magic Accuracy +2', '', '', ' NIN', 70, 'Dynamis - Buburimu / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Monster Belt', '[Waist] All Races', 'DEF: 5 CHR +6 Accuracy +7 Enmity -3', '', '', '', ' BST', 70, 'Dynamis - Qufim / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Saotome Koshi-Ate', '[Waist] All Races ', 'DEF: 4 DEX +5 Accuracy +7', 'Ranged Accuracy +7', '', '', ' SAM', 70, 'Dynamis - Qufim / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Sorcerer''s Belt', '[Waist] All Races ', 'DEF: 4 HP +20 INT +6 ', 'Spell interruption rate down 8% ', '', '', ' BLM', 70, 'Dynamis - Buburimu / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Summoner''s Cape', '[Back] All Races', 'DEF: 6 HP +30 MP +30 Enmity -1', '', '', '', ' SMN', 70, 'Dynamis - Qufim / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Valor Cape', '[Back] All Races', 'DEF: 16 HP +40 VIT +6 Enmity +3', '', '', '', ' PLD', 70, 'Dynamis - Buburimu / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Warrior''s Stone', '[Waist] All Races', 'DEF: 5 STR +5 Accuracy +7', 'Opponent''s critical hit rate -2%', '', '', ' WAR', 70, 'Dynamis - Buburimu / Dynamis - Valkurm', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Abyss Cape', '[Back] All Races', 'DEF: 6 Accuracy +7', 'Weapon Skill Accuracy +7', 'Magic Accuracy +7', '', ' DRK', 70, 'Dynamis - Buburimu / Dynamis - Qufim', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Duelist''s Belt', '[Waist] All Races ', 'DEF: 4 INT +4 MND +4 ', 'HP Recovered While Healing +4 ', 'MP Recovered While Healing +4 ', '', ' RDM', 70, 'Dynamis - Buburimu / Dynamis - Qufim', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Melee Cape', '[Back] All Races', 'DEF: 8 VIT +5 MND +5', 'HP recovered while healing +5', '', '', ' MNK', 70, 'Dynamis - Buburimu / Dynamis - Qufim', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Scout''s Belt', '[Waist] All Races ', 'DEF: 4 AGI +5 Ranged Accuracy +7', 'Ranged Attack +7', '', '', ' RNG', 70, 'Dynamis - Buburimu / Dynamis - Qufim', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Wyrm Belt', '[Waist] All Races', 'DEF: 5 VIT +5 Accuracy +7 Attack +7', '', '', '', ' DRG', 70, 'Dynamis - Buburimu / Dynamis - Qufim', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Beret', '[Head] All Races', 'DEF: 24 Accuracy +3 Evasion +3 Enmity -8', 'MP Recovered While Healing +2', '', '', ' BRD BLM RDM SCH SMN WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Doublet', '[Body] All Races', 'DEF: 43 MP +40 Accuracy +10', 'Evasion +10 Enmity -9', 'Enchantment: Adds ', '<20/20 0:30/[30:00, 0:30]>', ' BRD BLM RDM SCH SMN WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Gloves', '[Hands] All Races', 'DEF: 16 Accuracy +6', 'Evasion +6 Enmity -5', 'MP recovered while healing +1', '', ' BRD BLM RDM SCH SMN WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Brais', 'DEF: 32 Accuracy +10', 'Evasion +10 Enmity -6', 'MP recovered while healing +1', '', '', ' BRD BLM RDM SCH SMN WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Gaiters', '[Feet] All Races', 'DEF: 14 Accuracy +6 Evasion +6 Enmity -5', 'MP Recovered While Healing +2', '', '', ' BRD BLM RDM SCH SMN WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Tiara', '[Head] All Races ', 'DEF: 24 ', '<1/1 0:30/[20:00:00, 0:30]>', '', '', ' BRD BST BLU COR DNC DRK DRG MNK NIN PLD RNG RDM SAM THF WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Harness', '[Body] All Races ', 'DEF: 44', 'Enchantment: Attack +25 Ranged Attack +25 ', '<1/1 0:30/[20:00:00, 0:30]>', '', ' BRD BST BLU COR DNC DRK DRG MNK NIN PLD RNG RDM SAM THF WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Mittens', '[Hands] All Races ', 'DEF: 16', 'Enchantment: Accuracy +15', 'Ranged Accuracy +15 ', '<1/1 0:30/[20:00:00, 0:30]>', ' BRD BST BLU COR DNC DRK DRG MNK NIN PLD RNG RDM SAM THF WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Tights', '[Legs] All Races ', 'DEF: 32', 'Enchantment: \"Haste\"', '<1/1 0:30/[20:00:00, 0:30]>', '', ' BRD BST BLU COR DNC DRK DRG MNK NIN PLD RNG RDM SAM THF WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Spats', '[Feet] All Races ', 'DEF: 14', 'Enchantment: Evasion +15', '<1/1 0:30/[20:00:00, 0:30]>', '', ' BRD BST BLU COR DNC DRK DRG MNK NIN PLD RNG RDM SAM THF WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Salade', '[Head] All Races', 'DEF: 25 HP -20 MP +20', 'Accuracy +5 Enmity +7', '', '', ' DRK PLD WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Haubert', '[Body] All Races', 'DEF: 45 HP -20 MP +20', 'Accuracy +10 Enmity +9', 'Enchantment: Adds \"Refresh\" Effect', '<20/20 0:30/[30:00, 0:30]>', ' DRK PLD WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Moufles', '[Hands] All Races', 'DEF: 17 HP -18 MP +18', 'Accuracy +4 Enmity +6', '', '', ' DRK PLD WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Brayettes', '[Legs] All Races', 'DEF: 37 HP -30 MP +30', 'Accuracy +3 Enmity +6', '', '', ' DRK PLD WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Sollerets', '[Feet] All Races', 'DEF: 15 HP -35 MP +35', 'Accuracy +4 Enmity +4', '', '', ' DRK PLD WAR', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Cap', '[Head] All Races', 'DEF: 28', 'Fellow: HP +10 MP +10 INT +2', '', '', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Jupon', '[Body] All Races', 'DEF: 42 ', 'Fellow: HP +20 MP +20 VIT +2', '', '', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Bracers', '[Hands] All Races', 'DEF: 20 ', 'Fellow: HP +10 MP +10 DEX +2', '', '', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Hose', '[Legs] All Races', 'DEF: 35', 'Fellow: HP +10 MP +10 STR +2', '', '', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 70, 'Dynamis - Tavnazia', 'ismarc')",
"INSERT INTO ".$table_prefix."item_data (item_name, data_row_one, data_row_two, data_row_three, data_row_four, data_row_five, item_jobs, item_level, dropped_from, added_by) VALUES ('Hydra Boots', '[Feet] All Races', 'DEF: 18 ', 'Fellow: HP +10 MP +10 AGI +2', '', '', ' BRD BST BLM BLU COR DNC DRK DRG MNK NIN PLD PUP RNG RDM SAM SCH SMN THF WAR WHM', 70, 'Dynamis - Tavnazia', 'ismarc')"

);


   foreach ( $queries as $sql )
   {
       $db->query($sql);
   }


 $redir = "admin/config.php";
 redirect($redir);

 }

}

$manage = new Manage_Game;
$manage->do_it();


?>

